﻿USE [master]
GO
/****** Object:  Database [SFPopularize]    Script Date: 2015/12/21 16:14:06 ******/
CREATE DATABASE [SFPopularize]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'SFPopularize', FILENAME = N'G:\wxPopularize\DataBase\SFPopularize.mdf' , SIZE = 4608KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'SFPopularize_log', FILENAME = N'G:\wxPopularize\DataBase\SFPopularize_log.ldf' , SIZE = 16576KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [SFPopularize] SET COMPATIBILITY_LEVEL = 90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [SFPopularize].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [SFPopularize] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [SFPopularize] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [SFPopularize] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [SFPopularize] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [SFPopularize] SET ARITHABORT OFF 
GO
ALTER DATABASE [SFPopularize] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [SFPopularize] SET AUTO_CREATE_STATISTICS ON 
GO
ALTER DATABASE [SFPopularize] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [SFPopularize] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [SFPopularize] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [SFPopularize] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [SFPopularize] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [SFPopularize] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [SFPopularize] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [SFPopularize] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [SFPopularize] SET  DISABLE_BROKER 
GO
ALTER DATABASE [SFPopularize] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [SFPopularize] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [SFPopularize] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [SFPopularize] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [SFPopularize] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [SFPopularize] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [SFPopularize] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [SFPopularize] SET RECOVERY FULL 
GO
ALTER DATABASE [SFPopularize] SET  MULTI_USER 
GO
ALTER DATABASE [SFPopularize] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [SFPopularize] SET DB_CHAINING OFF 
GO
ALTER DATABASE [SFPopularize] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [SFPopularize] SET TARGET_RECOVERY_TIME = 0 SECONDS 
GO
EXEC sys.sp_db_vardecimal_storage_format N'SFPopularize', N'ON'
GO
USE [SFPopularize]
GO
/****** Object:  User [svndtcms]    Script Date: 2015/12/21 16:14:06 ******/
CREATE USER [svndtcms] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[dbo]
GO
/****** Object:  Table [dbo].[sf_appidmanage]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_appidmanage](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[businessNum] [nvarchar](50) NOT NULL,
	[templatesNum] [nvarchar](50) NULL,
	[appid_name] [nvarchar](100) NOT NULL,
	[appid_origin_id] [nvarchar](100) NOT NULL,
	[weixin_account] [nvarchar](100) NOT NULL,
	[avatar] [nvarchar](100) NULL,
	[interface_url] [nvarchar](200) NULL,
	[token_value] [nvarchar](100) NOT NULL,
	[encodingaeskey] [nvarchar](100) NOT NULL,
	[appid] [nvarchar](100) NULL,
	[appsecret] [nvarchar](100) NULL,
	[create_user] [nvarchar](50) NULL,
	[create_time] [nvarchar](50) NULL,
	[payment_name] [nvarchar](100) NOT NULL,
	[state] [int] NOT NULL,
	[weixin_pay_account] [nvarchar](100) NOT NULL,
	[account_pay_key] [nvarchar](100) NULL,
	[send_type] [int] NOT NULL,
	[logo] [nvarchar](200) NULL,
	[description] [nvarchar](1000) NULL,
 CONSTRAINT [PK_SF_APPIDMANAGE] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_auto_reply]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_auto_reply](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NULL,
	[templatesNum] [nvarchar](50) NULL,
	[appNum] [nvarchar](50) NULL,
	[replyText] [nvarchar](max) NULL,
	[isDefault] [int] NULL,
 CONSTRAINT [PK_sf_auto_reply] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_business_settlement]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_business_settlement](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[sf_finance_settlement_num] [nvarchar](100) NULL,
	[busnieseNum] [nvarchar](50) NULL,
	[businessName] [nvarchar](50) NULL,
	[sf_contract_num] [nvarchar](100) NULL,
	[settlement_times] [nvarchar](100) NULL,
	[user_name] [nvarchar](100) NULL,
	[total_amount] [decimal](18, 2) NULL,
	[state] [int] NULL,
	[pay_num] [nvarchar](100) NULL,
	[pay_time] [datetime] NULL,
	[notice_count] [int] NULL,
	[create_time] [datetime] NULL,
 CONSTRAINT [PK_SF_BUSINESS_SETTLEMENT] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_business_settlement_notice]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_business_settlement_notice](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[sf_finance_settlement_num] [nvarchar](100) NULL,
	[businessNum] [nvarchar](50) NULL,
	[content] [nvarchar](500) NULL,
	[type] [int] NULL,
	[user_name] [nvarchar](50) NULL,
	[time] [nvarchar](50) NULL,
 CONSTRAINT [PK_SF_BUSINESS_SETTLEMENT_NOTI] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_businessapp_settlement]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_businessapp_settlement](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[sf_finance_settlement_num] [nvarchar](100) NULL,
	[busnieseNum] [nvarchar](50) NULL,
	[business_name] [nvarchar](100) NULL,
	[appNum] [nvarchar](50) NULL,
	[appid_name] [nvarchar](100) NULL,
	[templatesNum] [nvarchar](100) NULL,
	[templates_name] [nvarchar](100) NULL,
	[sf_contract_num] [nvarchar](100) NULL,
	[settlement_times] [nvarchar](100) NULL,
	[user_name] [nvarchar](100) NULL,
	[total_amount] [decimal](18, 2) NULL,
	[create_time] [datetime] NULL,
 CONSTRAINT [PK_SF_BUSINESSAPP_SETTLEMENT] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_contract]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_contract](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NULL,
	[contract_num] [nvarchar](100) NULL,
	[contract_name] [nvarchar](100) NULL,
	[agreement] [text] NULL,
	[document] [nvarchar](200) NULL,
	[firstpart] [nvarchar](100) NULL,
	[secondpart] [nvarchar](100) NULL,
	[first_represent] [nvarchar](100) NULL,
	[first_person] [nvarchar](100) NULL,
	[first_address] [nvarchar](200) NULL,
	[first_fax] [nvarchar](100) NULL,
	[second_represent] [nvarchar](100) NULL,
	[second_person] [nvarchar](100) NULL,
	[second_address] [nvarchar](200) NULL,
	[second_fax] [nvarchar](100) NULL,
	[create_date] [datetime] NULL,
	[create_people] [nvarchar](100) NULL,
	[update_date] [datetime] NULL,
	[is_delete] [int] NULL,
 CONSTRAINT [PK_SF_CONTRACT] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_contract_child]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_contract_child](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[contract_num] [nvarchar](100) NULL,
	[appNum] [nvarchar](50) NULL,
	[pay_type] [int] NULL,
	[price_one] [float] NULL,
	[price_low] [float] NULL,
	[price_low_one] [float] NULL,
	[price_height] [float] NULL,
	[price_height_two] [float] NULL,
	[create_date] [datetime] NULL,
	[create_people] [nvarchar](100) NULL,
	[update_date] [datetime] NULL,
	[IsDelete] [int] NOT NULL,
 CONSTRAINT [PK_SF_CONTRACT_CHILD] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_door_function]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_door_function](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](50) NULL,
	[pics] [nvarchar](200) NULL,
	[remarks] [nvarchar](max) NULL,
	[bgColor] [nvarchar](50) NULL,
	[sort] [int] NULL,
	[status] [int] NULL,
 CONSTRAINT [PK_sf_door_function] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_door_help_center]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_door_help_center](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](100) NULL,
	[remarks] [nvarchar](max) NULL,
	[sort] [int] NULL,
 CONSTRAINT [PK_sf_door_help_center] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_door_index_pics]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_door_index_pics](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[classNum] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL,
	[remarks] [nvarchar](max) NULL,
	[pics] [nvarchar](200) NULL,
	[imgs] [nvarchar](200) NULL,
	[isDelete] [int] NULL,
 CONSTRAINT [PK_sf_door_index_pics] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_door_templates]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_door_templates](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[templatesNum] [nvarchar](50) NULL,
	[imgs] [nvarchar](max) NULL,
 CONSTRAINT [PK_sf_door_templates] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_door_words]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_door_words](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](50) NULL,
	[phone] [nvarchar](50) NULL,
	[remark] [nvarchar](200) NULL,
	[status] [int] NULL,
	[backMsg] [nvarchar](100) NULL,
 CONSTRAINT [PK_sf_door_words] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_finance_settlement]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_finance_settlement](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[settlement_num] [nvarchar](100) NULL,
	[user_name] [nvarchar](100) NULL,
	[total_amount] [decimal](18, 2) NULL,
	[received] [decimal](18, 2) NULL,
	[not_received] [decimal](18, 2) NULL,
	[state] [int] NULL,
	[create_time] [datetime] NULL,
 CONSTRAINT [PK_SF_FINANCE_SETTLEMENT] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_goods_alltype]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_goods_alltype](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[typeNum] [nvarchar](20) NULL,
	[typeName] [nvarchar](50) NULL,
 CONSTRAINT [PK_sf_goods_alltype] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_goods_amounts]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_goods_amounts](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NULL,
	[appNum] [nvarchar](50) NULL,
	[templatesNum] [nvarchar](50) NULL,
	[goodsNum] [nvarchar](50) NULL,
	[sizeId] [int] NULL,
	[colorId] [int] NULL,
	[colorUri] [nvarchar](max) NULL,
	[amount] [numeric](18, 0) NULL,
 CONSTRAINT [PK_sf_goods_amounts] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_goods_cart]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_goods_cart](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NOT NULL,
	[appNum] [nvarchar](50) NULL,
	[templatesNum] [nvarchar](50) NULL,
	[carNum] [nvarchar](50) NOT NULL,
	[userNum] [nvarchar](50) NULL,
	[goodsNum] [nvarchar](50) NULL,
	[addTime] [datetime] NULL,
	[price] [decimal](18, 2) NULL,
	[numbers] [int] NULL,
	[totalPrice] [decimal](18, 2) NULL,
	[amountId] [int] NULL,
 CONSTRAINT [PK_GOODS_SHOPCART] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_goods_color]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_goods_color](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NULL,
	[appNum] [nvarchar](50) NULL,
	[templatesNum] [nvarchar](50) NULL,
	[colorName] [nvarchar](50) NULL,
	[goodsTypeNum] [nvarchar](20) NULL,
 CONSTRAINT [PK_sf_goods_color] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_goods_express]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_goods_express](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NULL,
	[appNum] [nvarchar](50) NULL,
	[templatesNum] [nvarchar](50) NULL,
	[name] [nvarchar](20) NULL,
 CONSTRAINT [PK_sf_goods_express] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_goods_img]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_goods_img](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NULL,
	[appNum] [nvarchar](50) NULL,
	[templatesNum] [nvarchar](50) NULL,
	[goodsNum] [nvarchar](50) NULL,
	[imgName] [nvarchar](200) NULL,
	[imgUri] [nvarchar](200) NULL,
 CONSTRAINT [PK_sf_goods_img] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_goods_index_pics]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_goods_index_pics](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NULL,
	[appNum] [nvarchar](50) NULL,
	[templatesNum] [nvarchar](50) NULL,
	[titles] [nvarchar](100) NULL,
	[addTime] [datetime] NULL,
	[details] [nvarchar](max) NULL,
	[pics] [nvarchar](50) NULL,
	[isShow] [int] NULL,
	[sort] [int] NULL,
 CONSTRAINT [PK_SYS_INDEXINFO] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_goods_info]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_goods_info](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NULL,
	[appNum] [nvarchar](50) NULL,
	[templatesNum] [nvarchar](50) NULL,
	[goodsNum] [nvarchar](50) NOT NULL,
	[typeNum] [nvarchar](50) NULL,
	[names] [nvarchar](50) NULL,
	[brandName] [nvarchar](50) NULL,
	[place] [nvarchar](100) NULL,
	[unit] [nvarchar](10) NULL,
	[validTime] [nvarchar](50) NULL,
	[suitPerson] [nvarchar](50) NULL,
	[remark] [nvarchar](max) NULL,
	[times] [nvarchar](20) NULL,
	[num] [int] NULL,
	[costPrice] [decimal](18, 2) NULL,
	[showPrice] [decimal](18, 2) NULL,
	[salesPrice] [decimal](18, 2) NULL,
	[sort] [int] NULL,
	[showImgs] [nvarchar](50) NULL,
	[status] [int] NULL,
	[ishot] [int] NULL,
	[goodsTypeNum] [nvarchar](20) NULL,
 CONSTRAINT [PK_GOODS_INFO] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_goods_order]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_goods_order](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NULL,
	[appNum] [nvarchar](50) NULL,
	[templatesNum] [nvarchar](50) NULL,
	[orderNum] [nvarchar](50) NOT NULL,
	[userNum] [nvarchar](50) NULL,
	[totalMoney] [decimal](18, 2) NULL,
	[isPay] [int] NULL,
	[isUserDone] [int] NULL,
	[isComDone] [int] NULL,
	[addTime] [datetime] NULL,
	[payTime] [datetime] NULL,
	[addressNum] [nvarchar](50) NULL,
	[addressText] [nvarchar](max) NULL,
	[payWay] [int] NULL,
	[isExpress] [int] NULL,
	[expressName] [nvarchar](20) NULL,
	[expressNum] [nvarchar](50) NULL,
	[expressTime] [datetime] NULL,
	[comDoneTime] [datetime] NULL,
 CONSTRAINT [PK_GOODS_ORDERINFO] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_goods_orderdetal]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_goods_orderdetal](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NULL,
	[appNum] [nvarchar](50) NULL,
	[templatesNum] [nvarchar](50) NULL,
	[orderNum] [nvarchar](50) NOT NULL,
	[goodsNum] [nvarchar](50) NULL,
	[price] [decimal](18, 2) NULL,
	[numbers] [int] NULL,
	[totalMoney] [decimal](18, 2) NULL,
	[amountId] [int] NULL,
 CONSTRAINT [PK_GOODS_ORDERINFODETAL] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_goods_size]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_goods_size](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NULL,
	[appNum] [nvarchar](50) NULL,
	[templatesNum] [nvarchar](50) NULL,
	[sizeName] [nvarchar](50) NULL,
	[goodsTypeNum] [nvarchar](20) NULL,
 CONSTRAINT [PK_sf_goods_size] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_goods_types]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_goods_types](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NULL,
	[appNum] [nvarchar](50) NULL,
	[templatesNum] [nvarchar](50) NULL,
	[typeNum] [nvarchar](50) NOT NULL,
	[fatherId] [bigint] NULL,
	[name] [nvarchar](30) NULL,
	[sort] [int] NULL,
	[remark] [nvarchar](100) NULL,
	[class_layer] [int] NULL,
	[class_list] [nvarchar](100) NULL,
	[pics] [nvarchar](100) NULL,
	[isShow] [int] NULL,
	[goodsTypeNum] [nvarchar](20) NULL,
 CONSTRAINT [PK_GOODS_TYPES] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_manager]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_manager](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[role_id] [int] NULL,
	[role_type] [int] NULL,
	[busnieseNum] [nvarchar](50) NULL,
	[type] [int] NULL,
	[user_name] [nvarchar](100) NULL,
	[password] [nvarchar](100) NULL,
	[salt] [nvarchar](20) NULL,
	[real_name] [nvarchar](50) NULL,
	[telephone] [nvarchar](30) NULL,
	[email] [nvarchar](30) NULL,
	[is_lock] [int] NULL,
	[add_time] [datetime] NULL,
 CONSTRAINT [PK_ucenter_manager] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_manager_log]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_manager_log](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[user_id] [int] NULL,
	[user_name] [nvarchar](100) NULL,
	[action_type] [nvarchar](100) NULL,
	[remark] [nvarchar](255) NULL,
	[user_ip] [nvarchar](30) NULL,
	[add_time] [datetime] NULL,
 CONSTRAINT [PK_ucenter_manager_LOG] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_manager_notices]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_manager_notices](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[type] [tinyint] NULL,
	[post_user_name] [nvarchar](100) NULL,
	[post_user_real_name] [nvarchar](100) NULL,
	[accept_user_name] [nvarchar](100) NULL,
	[accept_user_real_name] [nvarchar](100) NULL,
	[is_read] [tinyint] NULL,
	[title] [nvarchar](100) NULL,
	[content] [ntext] NULL,
	[post_time] [datetime] NULL,
	[read_time] [datetime] NULL,
 CONSTRAINT [PK_SF_MANAGE_NOTICES] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_manager_role]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_manager_role](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[role_name] [nvarchar](100) NULL,
	[role_type] [tinyint] NULL,
	[is_sys] [tinyint] NULL,
 CONSTRAINT [PK_ucenter_manager_ROLE] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_manager_role_value]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_manager_role_value](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[role_id] [int] NULL,
	[nav_name] [nvarchar](100) NULL,
	[action_type] [nvarchar](50) NULL,
 CONSTRAINT [PK_ucenter_manager_ROLE_VALUE] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_manager_scale]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_manager_scale](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NULL,
	[appNum] [nvarchar](50) NULL,
	[templatesNum] [nvarchar](50) NULL,
	[levelName] [nvarchar](20) NULL,
	[scale] [float] NULL,
	[levels] [int] NULL,
 CONSTRAINT [PK_SYS_BRANCHMONEYSCALE] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_modeconfig]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_modeconfig](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[settingNum] [nvarchar](50) NULL,
	[call_encoding] [nvarchar](50) NULL,
	[goodstype_onshelf] [nvarchar](200) NULL,
	[settingname] [nvarchar](100) NULL,
	[marketing_type] [int] NULL,
	[imgurl] [nvarchar](300) NULL,
	[onshelf] [int] NULL,
	[isdelete] [int] NULL,
	[createtime] [datetime] NULL,
	[createman] [nvarchar](50) NULL,
	[remark] [nvarchar](500) NULL,
 CONSTRAINT [PK_SF_MODECONFIG] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_navigation]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_navigation](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[parent_id] [int] NULL,
	[channel_id] [int] NULL,
	[nav_type] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL,
	[title] [nvarchar](100) NULL,
	[sub_title] [nvarchar](100) NULL,
	[icon_url] [nvarchar](255) NULL,
	[link_url] [nvarchar](255) NULL,
	[sort_id] [int] NULL,
	[is_lock] [tinyint] NULL,
	[remark] [nvarchar](500) NULL,
	[action_type] [nvarchar](500) NULL,
	[is_sys] [tinyint] NULL,
 CONSTRAINT [PK_ucenter_navigation] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_notice]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_notice](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NOT NULL,
	[appNum] [nvarchar](50) NULL,
	[templatesNum] [nvarchar](50) NULL,
	[userNum] [nvarchar](50) NULL,
	[addTime] [datetime] NULL,
	[titles] [nvarchar](100) NULL,
	[details] [nvarchar](max) NULL,
 CONSTRAINT [PK_SYS_NOTICEINFO] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_ordersettlement]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_ordersettlement](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[sf_finance_settlement_num] [nvarchar](100) NOT NULL,
	[busnieseNum] [nvarchar](50) NOT NULL,
	[appNum] [nvarchar](50) NOT NULL,
	[templatesNum] [nvarchar](100) NOT NULL,
	[order_num] [nvarchar](100) NOT NULL,
	[payMoney] [decimal](18, 2) NOT NULL,
	[amount] [decimal](18, 2) NOT NULL,
	[settlement_time] [datetime] NOT NULL,
 CONSTRAINT [PK_SF_ORDERSETTLEMENT] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_reply_imgs]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_reply_imgs](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NULL,
	[appNum] [nvarchar](50) NULL,
	[keywords] [nvarchar](50) NULL,
	[matchModel] [int] NULL,
	[replyImg] [nvarchar](200) NULL,
	[replyMsg] [nvarchar](200) NULL,
	[addTime] [datetime] NULL,
 CONSTRAINT [PK_sf_reply_imgs] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_reply_sends]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_reply_sends](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NULL,
	[appNum] [nvarchar](50) NULL,
	[title] [nvarchar](50) NULL,
	[msgId] [nchar](10) NULL,
	[mediaId] [nvarchar](200) NULL,
	[msgType] [int] NULL,
	[userType] [int] NULL,
	[msgNum] [int] NULL,
	[uriMsg] [nvarchar](max) NULL,
	[textMsg] [nvarchar](max) NULL,
	[userMsg] [text] NULL,
	[addTime] [datetime] NULL,
 CONSTRAINT [PK_sf_reply_sends] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_reply_text]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_reply_text](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NULL,
	[appNum] [nvarchar](50) NULL,
	[keywords] [nvarchar](50) NULL,
	[matchModel] [int] NULL,
	[replyMsg] [nvarchar](200) NULL,
	[addTime] [datetime] NULL,
 CONSTRAINT [PK_sf_reply_text] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_user_address]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_user_address](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NOT NULL,
	[appNum] [nvarchar](50) NULL,
	[templatesNum] [nvarchar](50) NULL,
	[userNum] [nvarchar](50) NULL,
	[addressNum] [nvarchar](50) NOT NULL,
	[personName] [nvarchar](20) NULL,
	[phone] [nvarchar](20) NULL,
	[province] [nvarchar](20) NULL,
	[city] [nvarchar](20) NULL,
	[area] [nvarchar](20) NULL,
	[street] [nvarchar](50) NULL,
	[detailAddress] [nvarchar](100) NULL,
	[isDefault] [int] NULL,
	[postCode] [nvarchar](50) NULL,
 CONSTRAINT [PK_USER_ADDRESS] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_user_bank]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_user_bank](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NOT NULL,
	[appNum] [nvarchar](50) NULL,
	[templatesNum] [nvarchar](50) NULL,
	[userNum] [nvarchar](50) NULL,
	[bankNum] [nvarchar](50) NOT NULL,
	[personName] [nvarchar](20) NULL,
	[cardTypes] [int] NULL,
	[bankName] [nvarchar](20) NULL,
	[bankNumber] [nvarchar](30) NULL,
	[phone] [nvarchar](20) NULL,
 CONSTRAINT [PK_USER_BANKINFO] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_user_info]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_user_info](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NULL,
	[appNum] [nvarchar](50) NULL,
	[templatesNum] [nvarchar](50) NULL,
	[userNum] [nvarchar](50) NOT NULL,
	[nickName] [nvarchar](100) NULL,
	[province] [nvarchar](30) NULL,
	[city] [nvarchar](30) NULL,
	[addTime] [datetime] NULL,
	[openID] [nvarchar](100) NULL,
	[photoUri] [nvarchar](150) NULL,
	[isAttention] [int] NULL,
	[sellModel] [int] NULL,
	[inviteKey] [nvarchar](50) NULL,
	[fatherKey] [nvarchar](50) NULL,
 CONSTRAINT [PK_USER_USERINFO] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sf_user_withdraw_order]    Script Date: 2015/12/21 16:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_user_withdraw_order](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[busnieseNum] [nvarchar](50) NULL,
	[appNum] [nvarchar](50) NULL,
	[templatesNum] [nvarchar](50) NULL,
	[userNum] [nvarchar](50) NULL,
	[orderId] [nvarchar](50) NOT NULL,
	[addTime] [datetime] NULL,
	[money] [decimal](18, 0) NULL,
	[bankNum] [nvarchar](50) NULL,
	[status] [int] NULL,
 CONSTRAINT [PK_USER_CASHREPORT] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET IDENTITY_INSERT [dbo].[sf_door_function] ON 

INSERT [dbo].[sf_door_function] ([id], [name], [pics], [remarks], [bgColor], [sort], [status]) VALUES (2, N'自定义菜单', N'/upload/201509/08/201509081502488297.jpg', N'&lt;div&gt;<br />
&lt;h2&gt;@name&lt;/h2&gt;<br />
&lt;p&gt;自定义菜单最大的优点是降低了用户的认知门槛，可以将企业公众账号里的重点信息入口直观的暴露给用户。与通过发送消息然后系统返回信息的操作方式相比，自定义菜单更加有利于企业引导用户，体验更佳。&lt;/p&gt;<br />
&lt;p class="zongj"&gt;同时，自定义菜单与品牌微网站、移动商城相结合，会发挥出巨大的能效，其操作体验不亚于Native App。&lt;/p&gt;<br />
&lt;br/&gt;<br />
&lt;/div&gt;', N'white', 2, 0)
INSERT [dbo].[sf_door_function] ([id], [name], [pics], [remarks], [bgColor], [sort], [status]) VALUES (3, N'互动营销活动', N'/upload/201509/08/201509081503355796.jpg', N'&lt;div style="color:white;"&gt;<br />
&lt;h2&gt;@name&lt;/h2&gt;<br />
&lt;p&gt;利用微信的强交互性，通过对互动流程和方式的设计，以游戏、抽奖、问答等富媒体互动方式增加会员的黏性和忠诚度，最终实现在与会员的互动中达到营销的目的&lt;/p&gt;<br />
&lt;p&gt;数据表明，互动营销效果比单向的广告提升50%；另外，相对于通过第三平台，企业利用微信做营销更加方便直接，且信息是由企业自行发布，自由度及可信度更高。&lt;/p&gt;<br />
&lt;p&gt;同时，拥有丰富经验的申发商城专业运营团队将会辅助企业进行信息编辑和活动策划，使商家的营销达到最好的效果。&lt;/p&gt;<br />
&lt;p class="zongj"&gt;特色功能：开心大转盘，刮刮卡，砸金蛋，优惠券&lt;/p&gt;<br />
&lt;br/&gt;<br />
&lt;/div&gt;', N'#a4a078', 3, 0)
INSERT [dbo].[sf_door_function] ([id], [name], [pics], [remarks], [bgColor], [sort], [status]) VALUES (4, N'LBS推送', N'/upload/201509/08/201509081507281524.jpg', N'&lt;div&gt;<br />
&lt;h2&gt;@name&lt;/h2&gt;<br />
&lt;p&gt;LBS推送是由商家设置店铺位置，客户提交当前所在位置后，可以找到最近的商家店铺，并进行一键导航、一键拨号，如果店铺当前有进行的营销活动（如：优惠券、刮刮卡），也可把活动显示出来。&lt;/p&gt;<br />
&lt;/div&gt;', N'#eee', 4, 1)
INSERT [dbo].[sf_door_function] ([id], [name], [pics], [remarks], [bgColor], [sort], [status]) VALUES (5, N'品牌微网站', N'/upload/201509/08/201509081508355866.jpg', N'&lt;div&gt;<br />
&lt;h2&gt;@name&lt;/h2&gt;<br />
&lt;p&gt;微网站是指将企业信息、服务、活动等内容通过微信网页的方式进行表现，不但增加了信息展现量，也使信息的展示更加赏心悦目，进一步提高用户体验。是企业的智能业务员。&lt;/p&gt;<br />
&lt;p&gt;企业微网站为独立的模块，自主性高。网站的信息内容可以在后台随时调整，操作简单、管理方便。而且与企业微信无缝结合，让客户轻松获得更多信息，提高销售转化率。&lt;/p&gt;<br />
&lt;p class="zongj"&gt;特色功能：精美的网站模板，自适应屏幕，多媒体展示，一键拨号，一键导航&lt;/p&gt;<br />
&lt;/div&gt;', N'white', 5, 0)
INSERT [dbo].[sf_door_function] ([id], [name], [pics], [remarks], [bgColor], [sort], [status]) VALUES (6, N'微相册', N'/upload/201509/08/201509081509120891.jpg', N'<p>
	&lt;div&gt;<br />
&lt;h2&gt;@name&lt;/h2&gt;<br />
&lt;p&gt;在微相册里，您可以方便的创建相册，轻松地发布您需要展示的照片，还可以拓展为商家开展活动的一种展现方式。&lt;/p&gt;&lt;br/&gt;<br />
&lt;/div&gt;
</p>', N'#eee', 6, 1)
INSERT [dbo].[sf_door_function] ([id], [name], [pics], [remarks], [bgColor], [sort], [status]) VALUES (7, N'微社区', N'/upload/201509/08/201509081511005949.jpg', N'&lt;div&gt;<br />
&lt;h2&gt;@name&lt;/h2&gt;<br />
&lt;p&gt;“微社区“是一个能为商家带来巨大的社会化流量的功能，允许评论可以被分享于评论者的朋友圈、腾讯微博和发送给好友，这意味着评论可以被无数的粉丝分享，客户对商家进行实时且客观的评价，真实的社交环境保证了评论的客观性和有效性。&lt;/p&gt;&lt;br/&gt;<br />
&lt;/div&gt;', N'white', 7, 1)
INSERT [dbo].[sf_door_function] ([id], [name], [pics], [remarks], [bgColor], [sort], [status]) VALUES (8, N'在线预约', N'/upload/201509/08/201509081511393024.jpg', N'&lt;div&gt;<br />
&lt;h2&gt;@name&lt;/h2&gt;<br />
&lt;p&gt;通过微网Vip在线预约系统，企业相当于快速搭建一个移动互联网的电子商务平台，能有效地帮助企业打通线上线下，轻松实现O2O创新营销；助力企业拉进新客户，服务老客户。&lt;/p&gt;&lt;br/&gt;<br />
&lt;/div&gt;', N'#eee', 8, 1)
INSERT [dbo].[sf_door_function] ([id], [name], [pics], [remarks], [bgColor], [sort], [status]) VALUES (9, N'微调研', N'/upload/201509/08/201509081512579153.jpg', N'&lt;div&gt;<br />
&lt;h2&gt;@name&lt;/h2&gt;<br />
&lt;p&gt;微调研是一种以问卷调查的方式，基于微网Vip平台而展现出的一种新的在线调研应用方式，微调研已经完成调研项目数十个，涉及游戏、快速消费品、汽车、房产、美食、数码产品、家用电器等多个行业，具备有对微信用户进行生活形态研究的能力，客户随时随地的完成调查，帮助企业收集市场信息。&lt;/p&gt;&lt;br/&gt;<br />
&lt;/div&gt;', N'white', 9, 1)
INSERT [dbo].[sf_door_function] ([id], [name], [pics], [remarks], [bgColor], [sort], [status]) VALUES (10, N'会员卡', N'/upload/201509/08/201509081513410317.jpg', N'&lt;div style="color:white;"&gt;<br />
&lt;h2&gt;@name&lt;/h2&gt;<br />
&lt;p&gt;微网Vip会员卡通过在微信内植入会员卡，基于全国4亿微信用户，帮助企业建立集品牌推广、会员管理、营销活动、统计报表于一体的微信会员管理平台。清晰记录企业用户的消费行为并进行数据分析；还可根据用户特征进行精细分类，从而实现各种模式的精准营销。&lt;/p&gt;<br />
&lt;/div&gt;', N'#a4a078', 10, 1)
INSERT [dbo].[sf_door_function] ([id], [name], [pics], [remarks], [bgColor], [sort], [status]) VALUES (11, N'电子优惠券', N'/upload/201509/08/201509081515463689.jpg', N'&lt;div class="procon1"&gt;<br />
&lt;h2&gt;@name&lt;/h2&gt;<br />
&lt;p&gt;利用微网Vip优惠券系统，企业可以自行发行优惠券，用户只要关注企业的微信即可随时随地领取优惠券。并且每张优惠券的使用都有详细的数据记录，精确跟踪每一个顾客的消费习惯。&lt;/p&gt;<br />
&lt;/div&gt;', N'#eee', 11, 1)
INSERT [dbo].[sf_door_function] ([id], [name], [pics], [remarks], [bgColor], [sort], [status]) VALUES (12, N'移动商城', N'/upload/201509/08/201509081516527071.jpg', N'&lt;div&gt;<br />
&lt;h2&gt;@name&lt;/h2&gt;<br />
&lt;p&gt;目前，手机拥有率达到97.8%，但只有35.4%的人拥有个人电脑。客户不可能时时刻刻背着电脑，手机却是一直在身边的。建立一个移动商城，客户可以随时随地了解企业及产品信息，并且实现即时在线沟通，通过手机可以方便快捷地支付。&lt;/p&gt;<br />
&lt;p&gt;移动商城有利于潜在客户转化为实际消费客户。主要适用于传统品牌企业、行业连锁机构、淘宝商家等。&lt;/p&gt;<br />
&lt;p style="line-height: 45px;"&gt;特色功能：商品管理，订单管理，促销/团购系统，线上/线下支付&lt;/p&gt;&lt;br/&gt;<br />
&lt;/div&gt;', N'white', 12, 0)
INSERT [dbo].[sf_door_function] ([id], [name], [pics], [remarks], [bgColor], [sort], [status]) VALUES (13, N'商城模板', N'/upload/201509/14/201509141347551711.png', N'<span>&lt;div&gt;</span><br />
<span>&lt;h2&gt;@name&lt;/h2&gt;</span><br />
<span>&lt;p&gt;在商城配置里，您可以对商城模版进行选择，选择您中意的一款模版来展示您的信息列表。商城模版为您带来更多的信息展示方式，给客户一种新颖的感觉，不再局限于一种展示方式。&lt;/p&gt;</span><br />
<span>&lt;/div&gt;</span>', N'#eee', 1, 0)
SET IDENTITY_INSERT [dbo].[sf_door_function] OFF
SET IDENTITY_INSERT [dbo].[sf_door_help_center] ON 

INSERT [dbo].[sf_door_help_center] ([id], [name], [remarks], [sort]) VALUES (1, N'第一步', N'<p>
	&lt;h2&gt;如何为微信公众号配置接口？&lt;/h2&gt;<br />
&lt;p&gt;请务必认真阅读以下2步内容，才能更有效的完成配置工作，有疑问的请联系QQ：372682600提问。&lt;br/&gt;&lt;/p&gt;&lt;br/&gt;<br />
&lt;h2&gt;第一步、在申发商城绑定你的微信公众号。&lt;/h2&gt;
</p>
<p>
	&lt;p&gt;1、与申发科技签订商户合同，分配平台使用账号。&lt;/p&gt;
</p>
<p>
	&lt;p&gt;2、登录<span style="line-height:1.5;">&lt;a href=''http://www.aojieer.net/admin/login.aspx''&gt;<span>申发商城接口平台</span>&lt;/a&gt;&lt;/p&gt;</span> 
</p>
<p>
	&lt;p&gt;3、添加公众号 → 功能管理 → 配置使用的功能信息&lt;/p&gt;
</p>
<p>
	&lt;img src="imgs/20150914141301.png" /&gt;<br />
&lt;img src="imgs/20150914141306.png" /&gt;
</p>
<p>
	<br />
</p>', 1)
INSERT [dbo].[sf_door_help_center] ([id], [name], [remarks], [sort]) VALUES (2, N'第二步', N'&lt;h2&gt;第二步、到微信公众平台设置接口。&lt;/h2&gt;<br />
&lt;p&gt;1、登录 &lt;a href=''http://mp.weixin.qq.com/''&gt;微信公众平台&lt;/a&gt;，登录之后点击左侧菜单的“开发者中心”，下图红框中所示。&lt;/p&gt;<br />
&lt;img src="imgs/1.jpg" /&gt;<br />
&lt;p&gt;2、进入开发者中心之后，点击下图中绿色的“启用”按钮（&lt;span style="color: red;"&gt;如果按钮是红色的就忽略这个直接进入下一步&lt;/span&gt;），然后在弹出的页面里点击确定，然后点击下图中的“修改配置”（&lt;span style="color: red;"&gt;订阅号的开发者中心可能没有开发者ID、AppId和AppSecret，这属于正常的&lt;/span&gt;）&lt;/p&gt;<br />
&lt;img src="imgs/2.jpg" /&gt;<br />
&lt;p&gt;3、按照下面要求填写接口配置信息，填写后提交即可&lt;/p&gt;<br />
&lt;p&gt;URL填写：<a href="http://www.aojieer.net/AutoResponse.aspx</p">http://www.aojieer.net/AutoResponse.aspx&lt;/p</a>&gt;<br />
&lt;p&gt;Token填写 ：&lt;font color="red"&gt;微信平台与申发商城平台需一致&lt;/font&gt;&lt;/p&gt;<br />
&lt;p&gt;&lt;img src="imgs/5.jpg" /&gt;&lt;br /&gt;&lt;/p&gt;<br />
&lt;p&gt;4、在手机上用微信给你的公众号输入"帮助"，如果能接收到信息就接入成功，否则请按照以上步骤重新配置&lt;/p&gt;&lt;br/&gt;', 2)
SET IDENTITY_INSERT [dbo].[sf_door_help_center] OFF
SET IDENTITY_INSERT [dbo].[sf_door_index_pics] ON 

INSERT [dbo].[sf_door_index_pics] ([id], [classNum], [name], [remarks], [pics], [imgs], [isDelete]) VALUES (2, N'1', N'微信商城', N'强化品牌特性，&lt;br /&gt;缔造移动互联网时代新品牌形象。', N'/upload/201509/17/201509171507014476.jpg', N'/upload/201509/18/201509181647216964.png', 0)
INSERT [dbo].[sf_door_index_pics] ([id], [classNum], [name], [remarks], [pics], [imgs], [isDelete]) VALUES (3, N'1', N'微网站', N'整合完备的客户关系管理和&lt;br/&gt;客服成本控制机制，&lt;br/&gt;建立官方权威客服中心。', N'/upload/201509/17/201509171507555588.jpg', N'/upload/201509/18/201509181647492902.png', 0)
INSERT [dbo].[sf_door_index_pics] ([id], [classNum], [name], [remarks], [pics], [imgs], [isDelete]) VALUES (4, N'1', N'微信开发', N'连结线上线下，&lt;br/&gt;轻松实现O2O创新营销。', N'/upload/201509/17/201509171615457171.jpg', N'/upload/201509/18/201509181648225402.png', 0)
INSERT [dbo].[sf_door_index_pics] ([id], [classNum], [name], [remarks], [pics], [imgs], [isDelete]) VALUES (5, N'1', N'微网站制作', N'快速地搭建移动电子商务平台，&lt;br/&gt;低成本地开展移动营销。', N'/upload/201509/17/201509171508276892.jpg', N'/upload/201509/18/201509181648299933.png', 0)
INSERT [dbo].[sf_door_index_pics] ([id], [classNum], [name], [remarks], [pics], [imgs], [isDelete]) VALUES (9, N'2', N'1', N'&lt;div class="j-banner imgsize"&gt; &lt;img src="imgs/banner1.jpg" alt="申发商城轻松带领成千上万的微信用户一起为您销售商品" height="420" width="1920"&gt;&lt;div class="text"&gt;&lt;h2&gt;申发商城&lt;b&gt;专业的分销系统&lt;/b&gt;&lt;/h2&gt;&lt;h4&gt;轻松带领成千上万的微信用户&lt;br&gt;一起为您销售商品&lt;/h4&gt;&lt;/div&gt;&lt;a href="javascript:layer(''show'');" class="btn btn_exp"&gt;立即体验&lt;/a&gt;&lt;/div&gt;', N'/upload/201509/17/201509171616195087.jpg', N'', 0)
INSERT [dbo].[sf_door_index_pics] ([id], [classNum], [name], [remarks], [pics], [imgs], [isDelete]) VALUES (10, N'2', N'2', N'<span>&lt;div class="j-banner2 imgsize"&gt; &lt;img src="imgs/banner3.jpg" alt="传播力度大、销售效率高、可控制性强、专为微信打造" height="420" width="1920"&gt;&lt;div class="text"&gt;&lt;h2&gt;申发商城&lt;b&gt;专业的分销系统&lt;/b&gt;&lt;/h2&gt;&lt;h4&gt;传播力度大、销售效率高&lt;br&gt;可控制性强、专为微信打造&lt;/h4&gt;&lt;/div&gt;&lt;a href="javascript:layer(''show'');" class="btn btn_exp"&gt;立即体验&lt;/a&gt; &lt;/div&gt;</span>', N'/upload/201509/17/201509171510112280.jpg', N'', 0)
INSERT [dbo].[sf_door_index_pics] ([id], [classNum], [name], [remarks], [pics], [imgs], [isDelete]) VALUES (11, N'2', N'3', N'<span>&lt;div class="j-banner6 imgsize"&gt; &lt;img src="imgs/banner6.jpg" alt="微信分销" height="420" width="1920"&gt;&lt;div class="text"&gt;&lt;h2&gt;&lt;b&gt;&lt;/b&gt;微信支付佣金结算&lt;/h2&gt;&lt;h4&gt;使用企业接口发放佣金&lt;br&gt;快速收款、灵活便捷&lt;/h4&gt;&lt;/div&gt;&lt;a href="tencent://message/?uin=318510181&amp;amp;Site=%E5%92%A8%E8%AF%A2&amp;amp;Menu=yes" target="_top" class="btn btn_exp"&gt;立即咨询&lt;/a&gt; &lt;/div&gt;</span>', N'/upload/201509/17/201509171510243157.jpg', N'', 0)
SET IDENTITY_INSERT [dbo].[sf_door_index_pics] OFF
SET IDENTITY_INSERT [dbo].[sf_goods_alltype] ON 

INSERT [dbo].[sf_goods_alltype] ([Id], [typeNum], [typeName]) VALUES (1, N'clothes', N'衣服')
INSERT [dbo].[sf_goods_alltype] ([Id], [typeNum], [typeName]) VALUES (2, N'trousers', N'裤子')
INSERT [dbo].[sf_goods_alltype] ([Id], [typeNum], [typeName]) VALUES (3, N'shoes', N'鞋子')
INSERT [dbo].[sf_goods_alltype] ([Id], [typeNum], [typeName]) VALUES (4, N'maquillage', N'单品')
SET IDENTITY_INSERT [dbo].[sf_goods_alltype] OFF
SET IDENTITY_INSERT [dbo].[sf_manager] ON 

INSERT [dbo].[sf_manager] ([id], [role_id], [role_type], [busnieseNum], [type], [user_name], [password], [salt], [real_name], [telephone], [email], [is_lock], [add_time]) VALUES (1, 1, 1, N'', 0, N'admin', N'CBED48859A642797053889562C3766E6', N'24V0XZ', N'超级管理员', N'028-85660301', N'postmaster@shenfakeji.com', 0, CAST(0x0000A4EE00A78AA0 AS DateTime))
SET IDENTITY_INSERT [dbo].[sf_manager] OFF
SET IDENTITY_INSERT [dbo].[sf_manager_role] ON 

INSERT [dbo].[sf_manager_role] ([id], [role_name], [role_type], [is_sys]) VALUES (1, N'超级管理组', 1, 1)
INSERT [dbo].[sf_manager_role] ([id], [role_name], [role_type], [is_sys]) VALUES (5, N'基本管理组', 2, 0)
INSERT [dbo].[sf_manager_role] ([id], [role_name], [role_type], [is_sys]) VALUES (6, N'系统管理组', 2, 0)
INSERT [dbo].[sf_manager_role] ([id], [role_name], [role_type], [is_sys]) VALUES (8, N'商户1', 2, 0)
SET IDENTITY_INSERT [dbo].[sf_manager_role] OFF
SET IDENTITY_INSERT [dbo].[sf_manager_role_value] ON 

INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1438, 5, N'sys_contract', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1439, 5, N'sys_contract', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1440, 5, N'contract_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1441, 5, N'contract_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1442, 5, N'modeconfig_main', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1443, 5, N'modeconfig_main', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1444, 5, N'modeconfig_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1445, 5, N'modeconfig_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1446, 5, N'modeconfig_show', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1447, 5, N'modeconfig_show', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1448, 5, N'finance', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1449, 5, N'finance_settlement', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1450, 5, N'finance_settlement_past', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1451, 5, N'finance_settlement_past', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1452, 5, N'finance_settlement_current', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1453, 5, N'sys_door', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1454, 5, N'door_index_img_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1455, 5, N'door_index_img_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1456, 5, N'door_help_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1457, 5, N'door_help_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1458, 5, N'door_function_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1459, 5, N'door_function_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1460, 5, N'door_templates_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1461, 5, N'door_templates_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1462, 5, N'sys_controller', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1463, 5, N'sys_design', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1464, 5, N'sys_navigation', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1465, 5, N'sys_navigation', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1466, 5, N'sys_manager', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1467, 5, N'sys_notice', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1468, 5, N'sys_notice', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1469, 5, N'business_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1470, 5, N'business_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1471, 5, N'manager_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1472, 5, N'manager_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1473, 5, N'manager_role', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1474, 5, N'manager_role', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1475, 5, N'manager_log', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1476, 5, N'manager_log', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1477, 6, N'sys_contract', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1478, 6, N'sys_contract', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1479, 6, N'contract_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1480, 6, N'contract_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1481, 6, N'contract_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1482, 6, N'contract_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1483, 6, N'contract_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1484, 6, N'modeconfig_main', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1485, 6, N'modeconfig_main', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1486, 6, N'modeconfig_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1487, 6, N'modeconfig_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1488, 6, N'modeconfig_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1489, 6, N'modeconfig_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1490, 6, N'modeconfig_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1491, 6, N'modeconfig_show', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1492, 6, N'modeconfig_show', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1493, 6, N'finance', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1494, 6, N'finance_settlement', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1495, 6, N'finance_settlement_past', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1496, 6, N'finance_settlement_past', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1497, 6, N'finance_settlement_current', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1498, 6, N'finance_settlement_current', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1499, 6, N'sys_door', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1500, 6, N'door_index_img_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1501, 6, N'door_index_img_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1502, 6, N'door_index_img_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1503, 6, N'door_index_img_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1504, 6, N'door_index_img_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1505, 6, N'door_index_img_list', N'OnShelf')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1506, 6, N'door_index_img_list', N'OffShelf')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1507, 6, N'door_help_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1508, 6, N'door_help_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1509, 6, N'door_help_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1510, 6, N'door_help_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1511, 6, N'door_help_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1512, 6, N'door_function_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1513, 6, N'door_function_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1514, 6, N'door_function_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1515, 6, N'door_function_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1516, 6, N'door_function_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1517, 6, N'door_function_list', N'OnShelf')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1518, 6, N'door_function_list', N'OffShelf')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1519, 6, N'door_templates_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1520, 6, N'door_templates_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1521, 6, N'door_templates_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1522, 6, N'door_templates_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1523, 6, N'door_templates_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1524, 6, N'sys_controller', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1525, 6, N'sys_design', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1526, 6, N'sys_navigation', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1527, 6, N'sys_navigation', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1528, 6, N'sys_navigation', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1529, 6, N'sys_navigation', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1530, 6, N'sys_navigation', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1531, 6, N'sys_manager', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1532, 6, N'sys_notice', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1533, 6, N'sys_notice', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1534, 6, N'sys_notice', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1535, 6, N'sys_notice', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1536, 6, N'sys_notice', N'Delete')
GO
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1537, 6, N'business_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1538, 6, N'business_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1539, 6, N'business_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1540, 6, N'business_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1541, 6, N'business_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1542, 6, N'manager_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1543, 6, N'manager_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1544, 6, N'manager_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1545, 6, N'manager_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1546, 6, N'manager_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1547, 6, N'manager_role', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1548, 6, N'manager_role', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1549, 6, N'manager_role', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1550, 6, N'manager_role', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1551, 6, N'manager_role', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1552, 6, N'manager_log', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1553, 6, N'manager_log', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1554, 6, N'manager_log', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1555, 6, N'manager_log', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1556, 6, N'manager_log', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1557, 1, N'sys_contract', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1558, 1, N'sys_contract', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1559, 1, N'contract_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1560, 1, N'contract_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1561, 1, N'contract_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1562, 1, N'contract_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1563, 1, N'contract_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1564, 1, N'modeconfig_main', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1565, 1, N'modeconfig_main', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1566, 1, N'modeconfig_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1567, 1, N'modeconfig_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1568, 1, N'modeconfig_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1569, 1, N'modeconfig_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1570, 1, N'modeconfig_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1571, 1, N'modeconfig_show', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1572, 1, N'modeconfig_show', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1573, 1, N'finance', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1574, 1, N'finance_settlement', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1575, 1, N'finance_settlement_past', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1576, 1, N'finance_settlement_past', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1577, 1, N'finance_settlement_current', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1578, 1, N'finance_settlement_current', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1579, 1, N'sys_door', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1580, 1, N'door_index_img_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1581, 1, N'door_index_img_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1582, 1, N'door_index_img_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1583, 1, N'door_index_img_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1584, 1, N'door_index_img_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1585, 1, N'door_index_img_list', N'OnShelf')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1586, 1, N'door_index_img_list', N'OffShelf')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1587, 1, N'door_help_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1588, 1, N'door_help_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1589, 1, N'door_help_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1590, 1, N'door_help_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1591, 1, N'door_help_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1592, 1, N'door_function_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1593, 1, N'door_function_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1594, 1, N'door_function_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1595, 1, N'door_function_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1596, 1, N'door_function_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1597, 1, N'door_function_list', N'OnShelf')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1598, 1, N'door_function_list', N'OffShelf')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1599, 1, N'door_templates_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1600, 1, N'door_templates_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1601, 1, N'door_templates_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1602, 1, N'door_templates_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1603, 1, N'door_templates_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1604, 1, N'sys_controller', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1605, 1, N'sys_design', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1606, 1, N'sys_navigation', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1607, 1, N'sys_navigation', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1608, 1, N'sys_navigation', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1609, 1, N'sys_navigation', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1610, 1, N'sys_navigation', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1611, 1, N'sys_manager', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1612, 1, N'sys_notice', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1613, 1, N'sys_notice', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1614, 1, N'sys_notice', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1615, 1, N'sys_notice', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1616, 1, N'sys_notice', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1617, 1, N'business_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1618, 1, N'business_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1619, 1, N'business_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1620, 1, N'business_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1621, 1, N'business_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1622, 1, N'manager_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1623, 1, N'manager_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1624, 1, N'manager_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1625, 1, N'manager_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1626, 1, N'manager_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1627, 1, N'manager_role', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1628, 1, N'manager_role', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1629, 1, N'manager_role', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1630, 1, N'manager_role', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1631, 1, N'manager_role', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1632, 1, N'manager_log', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1633, 1, N'manager_log', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1634, 1, N'manager_log', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1635, 1, N'manager_log', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1636, 1, N'manager_log', N'Delete')
GO
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1637, 8, N'sys_goods_config', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1638, 8, N'sys_custom_reply', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1639, 8, N'auto_reply_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1640, 8, N'auto_reply_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1641, 8, N'auto_reply_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1642, 8, N'auto_reply_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1643, 8, N'auto_reply_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1644, 8, N'reply_text_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1645, 8, N'reply_text_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1646, 8, N'reply_text_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1647, 8, N'reply_text_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1648, 8, N'reply_text_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1649, 8, N'reply_imgs_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1650, 8, N'reply_imgs_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1651, 8, N'reply_imgs_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1652, 8, N'reply_imgs_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1653, 8, N'reply_imgs_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1654, 8, N'sys_custom_sends', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1655, 8, N'reply_sends_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1656, 8, N'reply_sends_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1657, 8, N'reply_sends_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1658, 8, N'reply_sends_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1659, 8, N'reply_sends_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1660, 8, N'sys_custom_menu', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1661, 8, N'WeChatMenu', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1662, 8, N'WeChatMenu', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1663, 8, N'WeChatMenu', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1664, 8, N'WeChatMenu', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1665, 8, N'sys_all_user', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1666, 8, N'sys_customer_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1667, 8, N'sys_customer_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1668, 8, N'sys_customer_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1669, 8, N'sys_goods', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1670, 8, N'sys_goods_citys', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1671, 8, N'malltemplet_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1672, 8, N'malltemplet_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1673, 8, N'sys_shezhi_index', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1674, 8, N'sys_shezhi_index', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1675, 8, N'sys_shezhi_index', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1676, 8, N'sys_shezhi_index', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1677, 8, N'sys_shezhi_index', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1678, 8, N'sys_shezhi_index', N'OnShelf')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1679, 8, N'sys_shezhi_index', N'OffShelf')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1680, 8, N'sys_goods_msgs', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1681, 8, N'goods_type_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1682, 8, N'goods_type_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1683, 8, N'goods_type_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1684, 8, N'goods_type_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1685, 8, N'goods_type_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1686, 8, N'goods_type_list', N'OnShelf')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1687, 8, N'goods_type_list', N'OffShelf')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1688, 8, N'goods_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1689, 8, N'goods_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1690, 8, N'goods_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1691, 8, N'goods_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1692, 8, N'goods_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1693, 8, N'goods_list', N'OnShelf')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1694, 8, N'goods_list', N'OffShelf')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1695, 8, N'sys_goods_order', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1696, 8, N'goods_orders_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1697, 8, N'goods_orders_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1698, 8, N'goods_orders_list', N'Delete')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1699, 8, N'app_list', N'Show')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1700, 8, N'app_list', N'View')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1701, 8, N'app_list', N'Add')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1702, 8, N'app_list', N'Edit')
INSERT [dbo].[sf_manager_role_value] ([id], [role_id], [nav_name], [action_type]) VALUES (1703, 8, N'app_list', N'Delete')
SET IDENTITY_INSERT [dbo].[sf_manager_role_value] OFF
SET IDENTITY_INSERT [dbo].[sf_manager_scale] ON 

INSERT [dbo].[sf_manager_scale] ([id], [busnieseNum], [appNum], [templatesNum], [levelName], [scale], [levels]) VALUES (1, N'B20151015101408', N'wxe68d84dbc2554452', N'MC0015', N'第一级', 0.25, 1)
INSERT [dbo].[sf_manager_scale] ([id], [busnieseNum], [appNum], [templatesNum], [levelName], [scale], [levels]) VALUES (2, N'B20151015101408', N'wxe68d84dbc2554452', N'MC0015', N'第三级', 0.1, 2)
INSERT [dbo].[sf_manager_scale] ([id], [busnieseNum], [appNum], [templatesNum], [levelName], [scale], [levels]) VALUES (3, N'B20151015101408', N'wxe68d84dbc2554452', N'MC0015', N'第三级', 0.05, 3)
INSERT [dbo].[sf_manager_scale] ([id], [busnieseNum], [appNum], [templatesNum], [levelName], [scale], [levels]) VALUES (4, N'B20151112110555', N'wx4956a21bd8b8671b', N'MC0016', N'第一级', 0, 1)
INSERT [dbo].[sf_manager_scale] ([id], [busnieseNum], [appNum], [templatesNum], [levelName], [scale], [levels]) VALUES (5, N'B20151112110555', N'wx4956a21bd8b8671b', N'MC0016', N'第三级', 0, 2)
INSERT [dbo].[sf_manager_scale] ([id], [busnieseNum], [appNum], [templatesNum], [levelName], [scale], [levels]) VALUES (6, N'B20151112110555', N'wx4956a21bd8b8671b', N'MC0016', N'第三级', 0, 3)
INSERT [dbo].[sf_manager_scale] ([id], [busnieseNum], [appNum], [templatesNum], [levelName], [scale], [levels]) VALUES (10001, N'B20151207111248', N'wx0b7e3ae9164b0fd9', N'MC0015', N'第一级', 0.1, 1)
INSERT [dbo].[sf_manager_scale] ([id], [busnieseNum], [appNum], [templatesNum], [levelName], [scale], [levels]) VALUES (10002, N'B20151207111248', N'wx0b7e3ae9164b0fd9', N'MC0015', N'第三级', 0.05, 2)
INSERT [dbo].[sf_manager_scale] ([id], [busnieseNum], [appNum], [templatesNum], [levelName], [scale], [levels]) VALUES (10003, N'B20151207111248', N'wx0b7e3ae9164b0fd9', N'MC0015', N'第三级', 0.03, 3)
INSERT [dbo].[sf_manager_scale] ([id], [busnieseNum], [appNum], [templatesNum], [levelName], [scale], [levels]) VALUES (10004, N'B20151015101408', N'wxdad588a851312642', N'MC0002', N'第一级', 0, 1)
INSERT [dbo].[sf_manager_scale] ([id], [busnieseNum], [appNum], [templatesNum], [levelName], [scale], [levels]) VALUES (10005, N'B20151015101408', N'wxdad588a851312642', N'MC0002', N'第三级', 0, 2)
INSERT [dbo].[sf_manager_scale] ([id], [busnieseNum], [appNum], [templatesNum], [levelName], [scale], [levels]) VALUES (10006, N'B20151015101408', N'wxdad588a851312642', N'MC0002', N'第三级', 0, 3)
SET IDENTITY_INSERT [dbo].[sf_manager_scale] OFF
SET IDENTITY_INSERT [dbo].[sf_modeconfig] ON 

INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (2, N'MC0001', N'weishangred', N'clothes', N'微商城衣服直销红色模版', 0, N'imgs/templetes/test11.png', 1, 0, CAST(0x0000A50E012CDB24 AS DateTime), N'超级管理员', NULL)
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (3, N'MC0002', N'weishanggreen', N'clothes', N'微商城衣服直销绿色模版', 0, N'imgs/templetes/test12.png', 1, 0, CAST(0x0000A50E012CDB24 AS DateTime), N'超级管理员', NULL)
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (4, N'MC0003', N'weishangred', N'clothes', N'微商城衣服分销红色模版', 1, N'imgs/templetes/test13.png', 1, 0, CAST(0x0000A50E012CDB24 AS DateTime), N'超级管理员', NULL)
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (5, N'MC0004', N'weishanggreen', N'clothes', N'微商城衣服分销绿色模版', 1, N'imgs/templetes/test14.png', 1, 0, CAST(0x0000A50E012CDB24 AS DateTime), N'超级管理员', NULL)
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (6, N'MC0005', N'weishangred', N'trousers', N'微商城裤子直销红色模版', 0, N'imgs/templetes/test21.png', 1, 0, CAST(0x0000A50E012CDB24 AS DateTime), N'超级管理员', NULL)
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (8, N'MC0006', N'weishanggreen', N'trousers', N'微商城裤子直销绿色模版', 0, N'imgs/templetes/test22.png', 1, 0, CAST(0x0000A50E012CDB24 AS DateTime), N'超级管理员', NULL)
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (9, N'MC0007', N'weishangred', N'trousers', N'微商城裤子分销红色模版', 1, N'imgs/templetes/test23.png', 1, 0, CAST(0x0000A50E012CDB24 AS DateTime), N'超级管理员', NULL)
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (10, N'MC0008', N'weishanggreen', N'trousers', N'微商城裤子分销绿色模版', 1, N'imgs/templetes/test24.png', 1, 0, CAST(0x0000A50E012CDB24 AS DateTime), N'超级管理员', NULL)
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (11, N'MC0009', N'weishangred', N'shoes', N'微商城鞋子直销红色模版', 0, N'imgs/templetes/test31.png', 1, 0, CAST(0x0000A50E012CDB24 AS DateTime), N'超级管理员', NULL)
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (12, N'MC0010', N'weishanggreen', N'shoes', N'微商城鞋子直销绿色模版', 0, N'imgs/templetes/test32.png', 1, 0, CAST(0x0000A50E012CDB24 AS DateTime), N'超级管理员', NULL)
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (13, N'MC0011', N'weishangred', N'shoes', N'微商城鞋子分销红色模版', 1, N'imgs/templetes/test33.png', 1, 0, CAST(0x0000A50E012CDB24 AS DateTime), N'超级管理员', NULL)
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (14, N'MC0012', N'weishanggreen', N'shoes', N'微商城鞋子分销绿色模版', 1, N'imgs/templetes/test34.png', 1, 0, CAST(0x0000A50E012CDB24 AS DateTime), N'超级管理员', NULL)
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (15, N'MC0013', N'weishangred', N'maquillage', N'微商城单品直销红色模版', 0, N'imgs/templetes/test41.png', 1, 0, CAST(0x0000A50E012CDB24 AS DateTime), N'超级管理员', NULL)
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (16, N'MC0014', N'weishanggreen', N'maquillage', N'微商城单品直销绿色模版', 0, N'imgs/templetes/test42.png', 1, 0, CAST(0x0000A50E012CDB24 AS DateTime), N'超级管理员', NULL)
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (17, N'MC0015', N'weishangred', N'maquillage', N'微商城单品分销红色模版', 1, N'imgs/templetes/test43.png', 1, 0, CAST(0x0000A50E012CDB24 AS DateTime), N'超级管理员', NULL)
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (18, N'MC0016', N'weishanggreen', N'maquillage', N'微商城单品分销绿色模版', 1, N'imgs/templetes/test44.png', 1, 0, CAST(0x0000A50E012CDB24 AS DateTime), N'超级管理员', NULL)
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (21, N'MB20150923020009', N'syj', N'clothes', N'水云衣服直销模版', 0, N'imgs/templetes/syj11.png', 1, 0, CAST(0x0000A51C00E6C1BA AS DateTime), N'超级管理员', N'')
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (22, N'MB20150923020040', N'syj', N'clothes', N'水云衣服分销模版', 1, N'imgs/templetes/syj12.png', 1, 0, CAST(0x0000A51C00E6E654 AS DateTime), N'超级管理员', N'')
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (23, N'MB20150923020106', N'syj', N'trousers', N'水云裤子直销模版', 0, N'imgs/templetes/syj21.png', 1, 0, CAST(0x0000A51C00E703E2 AS DateTime), N'超级管理员', N'')
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (24, N'MB20150923020123', N'syj', N'trousers', N'水云裤子分销模版', 1, N'imgs/templetes/syj22.png', 1, 0, CAST(0x0000A51C00E7180F AS DateTime), N'超级管理员', N'')
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (25, N'MB20150923020145', N'syj', N'shoes', N'水云鞋子直销模版', 0, N'imgs/templetes/syj31.png', 1, 0, CAST(0x0000A51C00E7328E AS DateTime), N'超级管理员', N'')
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (26, N'MB20150923020204', N'syj', N'shoes', N'水云鞋子分销模版', 1, N'imgs/templetes/syj32.png', 1, 0, CAST(0x0000A51C00E74862 AS DateTime), N'超级管理员', N'')
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (27, N'MB20150923020228', N'syj', N'maquillage', N'水云单品直销模版', 0, N'imgs/templetes/syj41.png', 1, 0, CAST(0x0000A51C00E764E0 AS DateTime), N'超级管理员', N'')
INSERT [dbo].[sf_modeconfig] ([id], [settingNum], [call_encoding], [goodstype_onshelf], [settingname], [marketing_type], [imgurl], [onshelf], [isdelete], [createtime], [createman], [remark]) VALUES (28, N'MB20150923020244', N'syj', N'maquillage', N'水云单品分销模版', 1, N'imgs/templetes/syj42.png', 1, 0, CAST(0x0000A51C00E7773D AS DateTime), N'超级管理员', N'')
SET IDENTITY_INSERT [dbo].[sf_modeconfig] OFF
SET IDENTITY_INSERT [dbo].[sf_navigation] ON 

INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (4, 0, 0, N'System', N'sys_controller', N'系统设置', N'系统设置', N'/admin/skin/default/nav/sys.png', N'', 88, 0, N'系统默认导航，不可更改导航ID', N'Show', 1)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (7, 4, 0, N'System', N'sys_manager', N'系统用户', N'', N'', N'', 103, 0, N'', N'Show', 1)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (8, 7, 0, N'System', N'manager_list', N'管理员管理', N'', N'', N'manager/manager_list.aspx', 99, 0, N'', N'Show,View,Add,Edit,Delete', 1)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (9, 7, 0, N'System', N'manager_role', N'角色管理', N'', N'', N'manager/role_list.aspx', 100, 0, N'', N'Show,View,Add,Edit,Delete', 1)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (10, 7, 0, N'System', N'manager_log', N'管理日志', N'', N'', N'manager/manager_log.aspx', 101, 0, N'', N'Show,View,Add,Edit,Delete', 1)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (19, 4, 0, N'System', N'sys_design', N'界面管理', N'', N'', N'', 102, 0, N'', N'Show', 1)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (22, 19, 0, N'System', N'sys_navigation', N'后台导航管理', N'', N'', N'settings/nav_list.aspx', 102, 0, N'', N'Show,View,Add,Edit,Delete', 1)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (146, 0, 0, N'System', N'sys_goods', N'商品管理', N'商品管理', N'/upload/201509/15/201509151644486652.png', N'', 62, 0, N'', N'Show', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (150, 185, 0, N'System', N'goods_list', N'商品列表', N'', N'', N'goods/goods_list.aspx', 97, 0, N'', N'Show,View,Add,Edit,Delete,OnShelf,OffShelf', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (153, 177, 0, N'System', N'goods_orders_list', N'订单列表', N'', N'', N'goods/orders/order_list.aspx', 99, 0, N'', N'Show,View,Delete', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (154, 185, 0, N'System', N'goods_type_list', N'商品分类', N'', N'', N'goods/goods_type_list.aspx', 96, 0, N'', N'Show,View,Add,Edit,Delete,OnShelf,OffShelf', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (155, 0, 0, N'System', N'sys_all_user', N'客户信息', N'客户管理', N'/upload/201509/15/201509151644371964.png', N'', 61, 0, N'', N'Show', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (156, 155, 0, N'System', N'sys_customer_list', N'客户列表', N'', N'', N'users/cur_list.aspx', 99, 0, N'', N'Show,View,Delete', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (157, 184, 0, N'System', N'sys_shezhi_index', N'商城活动图片', N'', N'', N'goods/index_img_list.aspx', 99, 0, N'', N'Show,View,Add,Edit,Delete,OnShelf,OffShelf', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (158, 0, 0, N'System', N'sys_contract', N'合同管理', N'合同管理', N'/upload/201509/15/201509151646023527.png', N'', 81, 0, N'', N'Show,View', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (159, 158, 0, N'System', N'contract_list', N'商户合同', N'', N'', N'contract/contract_list.aspx', 99, 0, N'', N'Show,View,Add,Edit,Delete', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (160, 7, 0, N'System', N'business_list', N'商户管理', N'', N'', N'manager/business_list.aspx', 99, 0, N'', N'Show,View,Add,Edit,Delete', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (161, 0, 0, N'System', N'finance', N'财务结算', N'财务结算', N'/upload/201509/15/201509151645128995.png', N'', 83, 0, N'', N'Show', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (162, 161, 0, N'System', N'finance_settlement', N'财务结算', N'', N'', N'', 99, 0, N'', N'Show', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (163, 7, 0, N'System', N'sys_notice', N'系统通知', N'', N'', N'manager/notice_list.aspx', 99, 0, N'', N'Show,View,Add,Edit,Delete', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (164, 162, 0, N'System', N'finance_settlement_past', N'结算记录', N'', N'', N'finance/finance_settlement_past.aspx', 97, 0, N'', N'Show,View', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (165, 162, 0, N'System', N'finance_settlement_current', N'生成结算单', N'', N'', N'finance/finance_settlement_current.aspx', 98, 0, N'', N'Show,View', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (167, 0, 0, N'System', N'sys_door', N'门户配置', N'门户配置', N'/upload/201509/15/201509151645224777.png', N'', 85, 0, N'', N'Show', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (168, 167, 0, N'System', N'door_templates_list', N'门户模版', N'', N'', N'door/door_templates_list.aspx', 99, 1, N'', N'Show,View,Add,Edit,Delete', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (169, 182, 0, N'System', N'auto_reply_list', N'关注时回复', N'', N'', N'goods/auto_reply_list.aspx', 80, 0, N'', N'Show,View,Add,Edit,Delete', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (170, 0, 0, N'System', N'modeconfig_main', N'模版管理', N'模版管理', N'/upload/201509/15/201509151646277120.png', N'', 82, 0, N'', N'Show,View', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (171, 170, 0, N'System', N'modeconfig_show', N'模版上架预览', N'', N'', N'modeconfig/modeconfig_preview.aspx', 99, 0, N'', N'Show,View', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (172, 170, 0, N'System', N'modeconfig_list', N'模版模式配置', N'', N'', N'modeconfig/modeconfig_list.aspx', 99, 0, N'', N'Show,View,Add,Edit,Delete', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (173, 0, 0, N'System', N'app_about', N'商户公众服务号', N'', N'/upload/201509/15/201509151645429777.png', N'', 108, 0, N'', N'Show', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (174, 173, 0, N'System', N'app_list', N'商户服务号管理', N'', N'', N'', 99, 0, N'', N'Show,View,Add,Edit,Delete', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (175, 184, 0, N'System', N'malltemplet_list', N'商城模版选择', N'', N'', N'modeconfig/malltemplet_list.aspx', 99, 0, N'', N'Show,View', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (176, 183, 0, N'System', N'WeChatMenu', N'菜单配置', N'', N'', N'weixin/WeChatMenu.aspx', 100, 0, N'', N'Show,View,Add,Edit', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (177, 0, 0, N'System', N'sys_goods_order', N'订单管理', N'订单管理', N'/upload/201509/15/201509151644582589.png', N'', 63, 0, N'', N'Show', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (178, 0, 0, N'System', N'sys_goods_config', N'微信功能', N'微信功能', N'/upload/201509/15/201509151644094933.png', N'', 60, 0, N'', N'Show', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (179, 167, 0, N'System', N'door_index_img_list', N'活动页面配置', N'', N'', N'door/door_index_img_list.aspx', 95, 0, N'', N'Show,View,Add,Edit,Delete,OnShelf,OffShelf', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (180, 167, 0, N'System', N'door_help_list', N'帮助中心配置', N'', N'', N'door/door_help_list.aspx', 96, 0, N'', N'Show,View,Add,Edit,Delete', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (181, 167, 0, N'System', N'door_function_list', N'功能模块配置', N'', N'', N'door/door_function_list.aspx', 97, 0, N'', N'Show,View,Add,Edit,Delete,OnShelf,OffShelf', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (182, 178, 0, N'System', N'sys_custom_reply', N'自定义回复', N'', N'', N'', 80, 0, N'', N'Show', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (183, 178, 0, N'System', N'sys_custom_menu', N'自定义菜单', N'', N'', N'', 99, 0, N'', N'Show', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (184, 146, 0, N'System', N'sys_goods_citys', N'商城配置', N'', N'', N'', 80, 0, N'', N'Show', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (185, 146, 0, N'System', N'sys_goods_msgs', N'商品信息', N'', N'', N'', 99, 0, N'', N'Show', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (186, 182, 0, N'System', N'reply_text_list', N'文本回复', N'', N'', N'gwxfun/reply_text_list.aspx', 82, 0, N'', N'Show,View,Add,Edit,Delete', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (187, 182, 0, N'System', N'reply_imgs_list', N'图文回复', N'', N'', N'gwxfun/reply_imgs_list.aspx', 84, 0, N'', N'Show,View,Add,Edit,Delete', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (188, 182, 0, N'System', N'333333', N'自动回复记录', N'', N'', N'', 99, 0, N'', N'Show,View,OnShelf,OffShelf', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (189, 161, 0, N'System', N'finance_notice', N'财务通知', N'', N'', N'', 100, 0, N'', N'', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (190, 189, 0, N'System', N'finance_notice_records', N'通知记录', N'通知记录', N'', N'manager/message_list.aspx', 99, 0, N'', N'', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (191, 178, 0, N'System', N'sys_custom_sends', N'客服消息', N'', N'', N'', 84, 0, N'', N'Show', 0)
INSERT [dbo].[sf_navigation] ([id], [parent_id], [channel_id], [nav_type], [name], [title], [sub_title], [icon_url], [link_url], [sort_id], [is_lock], [remark], [action_type], [is_sys]) VALUES (192, 191, 0, N'System', N'reply_sends_list', N'消息推送', N'', N'', N'gwxfun/reply_sends_list.aspx', 99, 0, N'', N'Show,View,Add,Edit,Delete', 0)
SET IDENTITY_INSERT [dbo].[sf_navigation] OFF
ALTER TABLE [dbo].[sf_goods_index_pics] ADD  DEFAULT ((0)) FOR [isShow]
GO
ALTER TABLE [dbo].[sf_goods_info] ADD  CONSTRAINT [DF__goods_Inf__statu__6462DE5A]  DEFAULT ((1)) FOR [status]
GO
ALTER TABLE [dbo].[sf_goods_info] ADD  CONSTRAINT [DF_goods_Info_ishot]  DEFAULT ((1)) FOR [ishot]
GO
ALTER TABLE [dbo].[sf_goods_order] ADD  CONSTRAINT [DF_goods_OrderInfo_isDone]  DEFAULT ((0)) FOR [isUserDone]
GO
ALTER TABLE [dbo].[sf_goods_order] ADD  CONSTRAINT [DF_goods_OrderInfo_addTime]  DEFAULT (getdate()) FOR [addTime]
GO
ALTER TABLE [dbo].[sf_goods_order] ADD  CONSTRAINT [DF_goods_OrderInfo_payWay]  DEFAULT ((1)) FOR [payWay]
GO
ALTER TABLE [dbo].[sf_manager] ADD  CONSTRAINT [DF__ucenter_manage__role___3D9E16F4]  DEFAULT ((2)) FOR [role_type]
GO
ALTER TABLE [dbo].[sf_manager] ADD  CONSTRAINT [DF__ucenter_manage__real___3E923B2D]  DEFAULT ('') FOR [real_name]
GO
ALTER TABLE [dbo].[sf_manager] ADD  CONSTRAINT [DF__ucenter_manage__telep__3F865F66]  DEFAULT ('') FOR [telephone]
GO
ALTER TABLE [dbo].[sf_manager] ADD  CONSTRAINT [DF__ucenter_manage__email__407A839F]  DEFAULT ('') FOR [email]
GO
ALTER TABLE [dbo].[sf_manager] ADD  CONSTRAINT [DF__ucenter_manage__is_lo__416EA7D8]  DEFAULT ((0)) FOR [is_lock]
GO
ALTER TABLE [dbo].[sf_manager] ADD  CONSTRAINT [DF__ucenter_manage__add_t__4262CC11]  DEFAULT (getdate()) FOR [add_time]
GO
ALTER TABLE [dbo].[sf_manager_log] ADD  DEFAULT (getdate()) FOR [add_time]
GO
ALTER TABLE [dbo].[sf_manager_role] ADD  DEFAULT ((0)) FOR [is_sys]
GO
ALTER TABLE [dbo].[sf_navigation] ADD  DEFAULT ((0)) FOR [parent_id]
GO
ALTER TABLE [dbo].[sf_navigation] ADD  DEFAULT ((0)) FOR [channel_id]
GO
ALTER TABLE [dbo].[sf_navigation] ADD  DEFAULT ('') FOR [nav_type]
GO
ALTER TABLE [dbo].[sf_navigation] ADD  DEFAULT ('') FOR [name]
GO
ALTER TABLE [dbo].[sf_navigation] ADD  DEFAULT ('') FOR [title]
GO
ALTER TABLE [dbo].[sf_navigation] ADD  DEFAULT ('') FOR [sub_title]
GO
ALTER TABLE [dbo].[sf_navigation] ADD  DEFAULT ('') FOR [link_url]
GO
ALTER TABLE [dbo].[sf_navigation] ADD  DEFAULT ((99)) FOR [sort_id]
GO
ALTER TABLE [dbo].[sf_navigation] ADD  DEFAULT ((0)) FOR [is_lock]
GO
ALTER TABLE [dbo].[sf_navigation] ADD  DEFAULT ('') FOR [remark]
GO
ALTER TABLE [dbo].[sf_navigation] ADD  DEFAULT ('') FOR [action_type]
GO
ALTER TABLE [dbo].[sf_navigation] ADD  DEFAULT ((0)) FOR [is_sys]
GO
ALTER TABLE [dbo].[sf_user_address] ADD  CONSTRAINT [DF_sf_user_address_isDefault]  DEFAULT ((0)) FOR [isDefault]
GO
ALTER TABLE [dbo].[sf_manager]  WITH CHECK ADD  CONSTRAINT [FK_UCENTER_MANAG_REFERENCE_UCENTER_MANAG] FOREIGN KEY([role_id])
REFERENCES [dbo].[sf_manager_role] ([id])
GO
ALTER TABLE [dbo].[sf_manager] CHECK CONSTRAINT [FK_UCENTER_MANAG_REFERENCE_UCENTER_MANAG]
GO
ALTER TABLE [dbo].[sf_manager_role_value]  WITH CHECK ADD  CONSTRAINT [FK_UCENTER_MANAG_REFERENCE_UCENTER_MANAG_ROLE_VALUE] FOREIGN KEY([role_id])
REFERENCES [dbo].[sf_manager_role] ([id])
GO
ALTER TABLE [dbo].[sf_manager_role_value] CHECK CONSTRAINT [FK_UCENTER_MANAG_REFERENCE_UCENTER_MANAG_ROLE_VALUE]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'回复内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_auto_reply', @level2type=N'COLUMN',@level2name=N'replyText'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否默认（0-非默认，1-默认）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_auto_reply', @level2type=N'COLUMN',@level2name=N'isDefault'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'功能名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_function', @level2type=N'COLUMN',@level2name=N'name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图片资源' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_function', @level2type=N'COLUMN',@level2name=N'pics'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_function', @level2type=N'COLUMN',@level2name=N'remarks'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'背景色' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_function', @level2type=N'COLUMN',@level2name=N'bgColor'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_function', @level2type=N'COLUMN',@level2name=N'sort'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态（0-正在使用，1-未使用）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_function', @level2type=N'COLUMN',@level2name=N'status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'步骤名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_help_center', @level2type=N'COLUMN',@level2name=N'name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'步骤内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_help_center', @level2type=N'COLUMN',@level2name=N'remarks'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'步骤顺序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_help_center', @level2type=N'COLUMN',@level2name=N'sort'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属类别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_index_pics', @level2type=N'COLUMN',@level2name=N'classNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_index_pics', @level2type=N'COLUMN',@level2name=N'name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'详细描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_index_pics', @level2type=N'COLUMN',@level2name=N'remarks'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'背景图' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_index_pics', @level2type=N'COLUMN',@level2name=N'pics'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图片（主针对首页使用）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_index_pics', @level2type=N'COLUMN',@level2name=N'imgs'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否下架' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_index_pics', @level2type=N'COLUMN',@level2name=N'isDelete'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'模版编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_templates', @level2type=N'COLUMN',@level2name=N'templatesNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'门户图片内容(，分割)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_templates', @level2type=N'COLUMN',@level2name=N'imgs'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_words', @level2type=N'COLUMN',@level2name=N'name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_words', @level2type=N'COLUMN',@level2name=N'phone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'具体信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_words', @level2type=N'COLUMN',@level2name=N'remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0-未处理，1-已处理' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_words', @level2type=N'COLUMN',@level2name=N'status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'处理时的反馈信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_door_words', @level2type=N'COLUMN',@level2name=N'backMsg'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自增Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_alltype', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品类型编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_alltype', @level2type=N'COLUMN',@level2name=N'typeNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品类型名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_alltype', @level2type=N'COLUMN',@level2name=N'typeName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自增Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_amounts', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商户编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_amounts', @level2type=N'COLUMN',@level2name=N'busnieseNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公众号编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_amounts', @level2type=N'COLUMN',@level2name=N'appNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'前台模版编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_amounts', @level2type=N'COLUMN',@level2name=N'templatesNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_amounts', @level2type=N'COLUMN',@level2name=N'goodsNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'尺码Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_amounts', @level2type=N'COLUMN',@level2name=N'sizeId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'颜色Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_amounts', @level2type=N'COLUMN',@level2name=N'colorId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品此颜色图片资源' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_amounts', @level2type=N'COLUMN',@level2name=N'colorUri'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'库存量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_amounts', @level2type=N'COLUMN',@level2name=N'amount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_cart', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_cart', @level2type=N'COLUMN',@level2name=N'goodsNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'添加时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_cart', @level2type=N'COLUMN',@level2name=N'addTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品单价' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_cart', @level2type=N'COLUMN',@level2name=N'price'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_cart', @level2type=N'COLUMN',@level2name=N'numbers'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'小计' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_cart', @level2type=N'COLUMN',@level2name=N'totalPrice'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'购物车信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_cart'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自增Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_color', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商户编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_color', @level2type=N'COLUMN',@level2name=N'busnieseNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公众号编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_color', @level2type=N'COLUMN',@level2name=N'appNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'前台模版编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_color', @level2type=N'COLUMN',@level2name=N'templatesNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'颜色名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_color', @level2type=N'COLUMN',@level2name=N'colorName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品类别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_color', @level2type=N'COLUMN',@level2name=N'goodsTypeNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自增Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_express', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商户编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_express', @level2type=N'COLUMN',@level2name=N'busnieseNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公众号编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_express', @level2type=N'COLUMN',@level2name=N'appNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'前台模版编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_express', @level2type=N'COLUMN',@level2name=N'templatesNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物流状态名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_express', @level2type=N'COLUMN',@level2name=N'name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_index_pics', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_index_pics', @level2type=N'COLUMN',@level2name=N'titles'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发布时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_index_pics', @level2type=N'COLUMN',@level2name=N'addTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_index_pics', @level2type=N'COLUMN',@level2name=N'details'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图片' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_index_pics', @level2type=N'COLUMN',@level2name=N'pics'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否推荐(1 是 0  否)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_index_pics', @level2type=N'COLUMN',@level2name=N'isShow'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统模块[首页顶部图片]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_index_pics'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自增Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商户编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'busnieseNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公众号编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'appNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'前台模版编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'templatesNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'goodsNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类型编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'typeNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'names'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'品牌名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'brandName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产地' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'place'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'unit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'有效期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'validTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'适合人群' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'suitPerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'其他描述(包含文字和图片混排)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上市年月' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'times'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数量（针对无其它属性商品）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'num'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'进货价' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'costPrice'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'显示价' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'showPrice'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'销售价' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'salesPrice'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'sort'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品图片' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'showImgs'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1-新品上架（默认），2-精选商品，3-特惠商品' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'ishot'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品类别，例：衣服、裤子、鞋子' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info', @level2type=N'COLUMN',@level2name=N'goodsTypeNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品详情' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_info'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自增Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_order', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商户编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_order', @level2type=N'COLUMN',@level2name=N'busnieseNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公众号编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_order', @level2type=N'COLUMN',@level2name=N'appNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'前台模版编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_order', @level2type=N'COLUMN',@level2name=N'templatesNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_order', @level2type=N'COLUMN',@level2name=N'orderNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_order', @level2type=N'COLUMN',@level2name=N'userNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'小计' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_order', @level2type=N'COLUMN',@level2name=N'totalMoney'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_order', @level2type=N'COLUMN',@level2name=N'isPay'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户结算(1已结算 0 未结算)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_order', @level2type=N'COLUMN',@level2name=N'isUserDone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公司财务结算（0-未结算，1-已结算）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_order', @level2type=N'COLUMN',@level2name=N'isComDone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'添加时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_order', @level2type=N'COLUMN',@level2name=N'addTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_order', @level2type=N'COLUMN',@level2name=N'payTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地址编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_order', @level2type=N'COLUMN',@level2name=N'addressNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地址信息（固态地址，针对地址编号无数据）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_order', @level2type=N'COLUMN',@level2name=N'addressText'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付方式（1-微支付）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_order', @level2type=N'COLUMN',@level2name=N'payWay'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物流状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_order', @level2type=N'COLUMN',@level2name=N'isExpress'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_order'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_orderdetal', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商户编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_orderdetal', @level2type=N'COLUMN',@level2name=N'busnieseNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公众号编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_orderdetal', @level2type=N'COLUMN',@level2name=N'appNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'前台模版编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_orderdetal', @level2type=N'COLUMN',@level2name=N'templatesNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单编号(关联订单信息表)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_orderdetal', @level2type=N'COLUMN',@level2name=N'orderNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_orderdetal', @level2type=N'COLUMN',@level2name=N'goodsNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品单价' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_orderdetal', @level2type=N'COLUMN',@level2name=N'price'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_orderdetal', @level2type=N'COLUMN',@level2name=N'numbers'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'小计' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_orderdetal', @level2type=N'COLUMN',@level2name=N'totalMoney'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品库存Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_orderdetal', @level2type=N'COLUMN',@level2name=N'amountId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单明细表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_orderdetal'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自增Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_size', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商户编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_size', @level2type=N'COLUMN',@level2name=N'busnieseNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公众号编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_size', @level2type=N'COLUMN',@level2name=N'appNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'前台模版编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_size', @level2type=N'COLUMN',@level2name=N'templatesNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'尺码名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_size', @level2type=N'COLUMN',@level2name=N'sizeName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类别Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_size', @level2type=N'COLUMN',@level2name=N'goodsTypeNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_types', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商户编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_types', @level2type=N'COLUMN',@level2name=N'busnieseNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公众号编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_types', @level2type=N'COLUMN',@level2name=N'appNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'前台模版编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_types', @level2type=N'COLUMN',@level2name=N'templatesNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分类编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_types', @level2type=N'COLUMN',@level2name=N'typeNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父级分类Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_types', @level2type=N'COLUMN',@level2name=N'fatherId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分类名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_types', @level2type=N'COLUMN',@level2name=N'name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_types', @level2type=N'COLUMN',@level2name=N'sort'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_types', @level2type=N'COLUMN',@level2name=N'remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分类层级' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_types', @level2type=N'COLUMN',@level2name=N'class_layer'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图片' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_types', @level2type=N'COLUMN',@level2name=N'pics'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否推荐(1 推荐 0  未推荐)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_types', @level2type=N'COLUMN',@level2name=N'isShow'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品类别编号，例：衣服、裤子、鞋子' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_types', @level2type=N'COLUMN',@level2name=N'goodsTypeNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品分类' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_goods_types'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自增ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager', @level2type=N'COLUMN',@level2name=N'role_id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'管理员类型1超管2系管' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager', @level2type=N'COLUMN',@level2name=N'role_type'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商户编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager', @level2type=N'COLUMN',@level2name=N'busnieseNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类型（0-系统，1-商户）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager', @level2type=N'COLUMN',@level2name=N'type'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager', @level2type=N'COLUMN',@level2name=N'user_name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager', @level2type=N'COLUMN',@level2name=N'password'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6位随机字符串,加密用到' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager', @level2type=N'COLUMN',@level2name=N'salt'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户昵称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager', @level2type=N'COLUMN',@level2name=N'real_name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager', @level2type=N'COLUMN',@level2name=N'telephone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电子邮箱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager', @level2type=N'COLUMN',@level2name=N'email'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否锁定' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager', @level2type=N'COLUMN',@level2name=N'is_lock'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'添加时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager', @level2type=N'COLUMN',@level2name=N'add_time'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'管理员信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自增ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_log', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_log', @level2type=N'COLUMN',@level2name=N'user_id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_log', @level2type=N'COLUMN',@level2name=N'user_name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_log', @level2type=N'COLUMN',@level2name=N'action_type'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_log', @level2type=N'COLUMN',@level2name=N'remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户IP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_log', @level2type=N'COLUMN',@level2name=N'user_ip'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_log', @level2type=N'COLUMN',@level2name=N'add_time'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'管理日志表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_log'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自增ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_role', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_role', @level2type=N'COLUMN',@level2name=N'role_name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_role', @level2type=N'COLUMN',@level2name=N'role_type'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否系统默认0否1是' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_role', @level2type=N'COLUMN',@level2name=N'is_sys'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'管理角色表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_role'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自增ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_role_value', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_role_value', @level2type=N'COLUMN',@level2name=N'role_id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'导航名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_role_value', @level2type=N'COLUMN',@level2name=N'nav_name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'权限类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_role_value', @level2type=N'COLUMN',@level2name=N'action_type'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'管理角色权限表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_role_value'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_scale', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'层级名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_scale', @level2type=N'COLUMN',@level2name=N'levelName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'比例数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_scale', @level2type=N'COLUMN',@level2name=N'scale'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'层级' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_scale', @level2type=N'COLUMN',@level2name=N'levels'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'抽成比例配置' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_manager_scale'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自增ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_navigation', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属父导航ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_navigation', @level2type=N'COLUMN',@level2name=N'parent_id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属频道ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_navigation', @level2type=N'COLUMN',@level2name=N'channel_id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'导航类别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_navigation', @level2type=N'COLUMN',@level2name=N'nav_type'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'导航ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_navigation', @level2type=N'COLUMN',@level2name=N'name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_navigation', @level2type=N'COLUMN',@level2name=N'title'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'副标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_navigation', @level2type=N'COLUMN',@level2name=N'sub_title'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图标地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_navigation', @level2type=N'COLUMN',@level2name=N'icon_url'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'链接地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_navigation', @level2type=N'COLUMN',@level2name=N'link_url'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序数字' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_navigation', @level2type=N'COLUMN',@level2name=N'sort_id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否隐藏0显示1隐藏' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_navigation', @level2type=N'COLUMN',@level2name=N'is_lock'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注说明' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_navigation', @level2type=N'COLUMN',@level2name=N'remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'权限资源' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_navigation', @level2type=N'COLUMN',@level2name=N'action_type'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统默认' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_navigation', @level2type=N'COLUMN',@level2name=N'is_sys'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统导航菜单' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_navigation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_notice', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发布人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_notice', @level2type=N'COLUMN',@level2name=N'userNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发布时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_notice', @level2type=N'COLUMN',@level2name=N'addTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_notice', @level2type=N'COLUMN',@level2name=N'titles'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_notice', @level2type=N'COLUMN',@level2name=N'details'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统模块[通知信息]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_notice'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'关键字' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_reply_imgs', @level2type=N'COLUMN',@level2name=N'keywords'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'匹配模式（0-包含，1-相同）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_reply_imgs', @level2type=N'COLUMN',@level2name=N'matchModel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'回复图文的图片信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_reply_imgs', @level2type=N'COLUMN',@level2name=N'replyImg'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'回复图文的文字信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_reply_imgs', @level2type=N'COLUMN',@level2name=N'replyMsg'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发送成功后返回的id（用于删除此信息）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_reply_sends', @level2type=N'COLUMN',@level2name=N'msgId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'推送资源的midiaid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_reply_sends', @level2type=N'COLUMN',@level2name=N'mediaId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'信息类型（0-文本，1-图片，2-图文，3-声音，4-视频）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_reply_sends', @level2type=N'COLUMN',@level2name=N'msgType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户类型（直接群发-0，选择用户-1）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_reply_sends', @level2type=N'COLUMN',@level2name=N'userType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'信息条数（图文最多为5，其它1）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_reply_sends', @level2type=N'COLUMN',@level2name=N'msgNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本地资源的uri地址 ，拼接' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_reply_sends', @level2type=N'COLUMN',@level2name=N'uriMsg'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文本信息， |^| 拼接' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_reply_sends', @level2type=N'COLUMN',@level2name=N'textMsg'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户的openid ，拼接 ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_reply_sends', @level2type=N'COLUMN',@level2name=N'userMsg'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'关键字' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_reply_text', @level2type=N'COLUMN',@level2name=N'keywords'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'匹配模式（0-包含，1-相同）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_reply_text', @level2type=N'COLUMN',@level2name=N'matchModel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'回复文本消息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_reply_text', @level2type=N'COLUMN',@level2name=N'replyMsg'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'添加时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_reply_text', @level2type=N'COLUMN',@level2name=N'addTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_address', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'收货人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_address', @level2type=N'COLUMN',@level2name=N'personName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'手机号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_address', @level2type=N'COLUMN',@level2name=N'phone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'省份' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_address', @level2type=N'COLUMN',@level2name=N'province'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'市' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_address', @level2type=N'COLUMN',@level2name=N'city'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'区' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_address', @level2type=N'COLUMN',@level2name=N'area'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'街道' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_address', @level2type=N'COLUMN',@level2name=N'street'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'详细地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_address', @level2type=N'COLUMN',@level2name=N'detailAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否是默认（1 是 0 不是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_address', @level2type=N'COLUMN',@level2name=N'isDefault'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'邮政编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_address', @level2type=N'COLUMN',@level2name=N'postCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户地址信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_address'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_bank', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'持卡人姓名(数据库加密)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_bank', @level2type=N'COLUMN',@level2name=N'personName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'卡类型(1 储蓄卡 2 信用卡 3 支付宝)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_bank', @level2type=N'COLUMN',@level2name=N'cardTypes'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属银行(数据库加密)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_bank', @level2type=N'COLUMN',@level2name=N'bankName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'银行卡号、支付宝帐号(数据库加密)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_bank', @level2type=N'COLUMN',@level2name=N'bankNumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预留手机号(数据库加密)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_bank', @level2type=N'COLUMN',@level2name=N'phone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'银行卡信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_bank'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自增Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_info', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商户编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_info', @level2type=N'COLUMN',@level2name=N'busnieseNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公众号编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_info', @level2type=N'COLUMN',@level2name=N'appNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'前台模版编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_info', @level2type=N'COLUMN',@level2name=N'templatesNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_info', @level2type=N'COLUMN',@level2name=N'userNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户昵称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_info', @level2type=N'COLUMN',@level2name=N'nickName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'省份' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_info', @level2type=N'COLUMN',@level2name=N'province'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'城市' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_info', @level2type=N'COLUMN',@level2name=N'city'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'添加时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_info', @level2type=N'COLUMN',@level2name=N'addTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'微信openId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_info', @level2type=N'COLUMN',@level2name=N'openID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户头像' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_info', @level2type=N'COLUMN',@level2name=N'photoUri'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'关注状态（1-已关注，0-未关注）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_info', @level2type=N'COLUMN',@level2name=N'isAttention'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'销售模式Id（0-直销，1-分销...）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_info', @level2type=N'COLUMN',@level2name=N'sellModel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'邀请码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_info', @level2type=N'COLUMN',@level2name=N'inviteKey'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父级邀请码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_info', @level2type=N'COLUMN',@level2name=N'fatherKey'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_withdraw_order', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_withdraw_order', @level2type=N'COLUMN',@level2name=N'orderId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_withdraw_order', @level2type=N'COLUMN',@level2name=N'addTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'金额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_withdraw_order', @level2type=N'COLUMN',@level2name=N'money'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户提现记录' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sf_user_withdraw_order'
GO
USE [master]
GO
ALTER DATABASE [SFPopularize] SET  READ_WRITE 
GO
